Summary of Wind Turbine Data

This section is to quickly summarize the values:

The goal is to automatically calculate the following summary statistics for the main data set provided.

Data set was for test Wind Farm

Site.Name WTG.Count Manufacturer Rating (kW)
test 73 ge 2500
DataSet_Total.Num.WTgs DataSet_Total.WTGs.Data WTG.Count.diff Duplicated.WTGs
73 73 No missing WTGs No
CSV_Row_Count = 21096 
               MissingData_count BlankData_count
TimeStamp10Min                 0               0
WTG                            0               0
RealPower                      0               0
WindSpeed                      0               0
Rating                         0               0
Below is a list of WTGs and their individual power rating. If there are more than one type of 
    WTG power rating the different rating will be shown in different colors.
WTG Rating (k/w)
WTG-0001 2500
WTG-0002 2500
WTG-0003 2500
WTG-0004 2500
WTG-0005 2500
WTG-0006 2500
WTG-0007 2500
WTG-0008 2500
WTG-0009 2500
WTG-0010 2500
WTG-0011 2500
WTG-0012 2500
WTG-0013 2500
WTG-0014 2500
WTG-0015 2500
WTG-0016 2500
WTG-0017 2500
WTG-0018 2500
WTG-0019 2500
WTG-0020 2500
WTG-0021 2500
WTG-0022 2500
WTG-0023 2500
WTG-0024 2500
WTG-0025 2500
WTG-0026 2500
WTG-0027 2500
WTG-0028 2500
WTG-0029 2500
WTG-0030 2500
WTG-0031 2500
WTG-0032 2500
WTG-0033 2500
WTG-0034 2500
WTG-0035 2500
WTG-0036 2500
WTG-0037 2500
WTG-0038 2500
WTG-0039 2500
WTG-0040 2500
WTG-0041 2500
WTG-0042 2500
WTG-0043 2500
WTG-0044 2500
WTG-0045 2500
WTG-0046 2500
WTG-0047 2500
WTG-0048 2500
WTG-0049 2500
WTG-0050 2500
WTG-0051 2500
WTG-0052 2500
WTG-0053 2500
WTG-0054 2500
WTG-0055 2500
WTG-0056 2500
WTG-0057 2500
WTG-0058 2500
WTG-0059 2500
WTG-0060 2500
WTG-0061 2500
WTG-0062 2500
WTG-0063 2500
WTG-0064 2500
WTG-0065 2500
WTG-0066 2500
WTG-0067 2500
WTG-0068 2500
WTG-0069 2500
WTG-0070 2500
WTG-0071 2500
WTG-0072 2500
WTG-0073 2500

RealPower and WindSpeed Summary:

Summary values below are for RealPower and WindSpeed Values for the full data set with all WTGs combined:

  • Min: The minimum value
  • 1st Qu: The value of the 1st quartile (25th percentile)
  • Median: The median value
  • 3rd Qu: The value of the 3rd quartile (75th percentile)
  • Max: The maximum value
RealPower WindSpeed
X Min. : -24.471 Min. : 0.000
X.1 1st Qu.: -4.211 1st Qu.: 4.711
X.2 Median : 223.686 Median : 6.348
X.3 Mean : 738.525 Mean : 6.403
X.4 3rd Qu.:1402.300 3rd Qu.: 8.261
X.5 Max. :2831.540 Max. :15.930

Sample of CSV Dataset: 10 Rows

   TimeStamp10Min      WTG RealPower WindSpeed Rating
1      2024-12-23 WTG-0001    -4.199     5.582   2500
2      2024-12-23 WTG-0001    -3.827     5.725   2500
3      2024-12-23 WTG-0001    -3.865     5.856   2500
4      2024-12-23 WTG-0001    -3.278     6.027   2500
5      2024-12-23 WTG-0001    -3.388     6.055   2500
6      2024-12-23 WTG-0001    -3.200     5.947   2500
7      2024-12-23 WTG-0001    -3.404     5.967   2500
8      2024-12-23 WTG-0001    -2.940     5.773   2500
9      2024-12-23 WTG-0001    -2.964     5.896   2500
10     2024-12-23 WTG-0001    -3.004     5.755   2500

RealPower / MaxPower Test for Each WTG

Test for Power Production

WTG’s that FAIL a test below will be highlighted RED if one or both of these conditions are not achieved:

  • ReachRated_hrs:
    • If Max-RealPower did NOT exceed the Rated power for at least one 10min timestamp.
    • WTG’s that are highlighted Green have shown to pass.
  • 98% of Rated:
    • Max power has at least achieved 98% of manufacturers Rated Power rating.
    • WTG’s that are highlighted Green have shown to pass.

Notification of possible issues

WTG’s will be highlighted Orange if these conditions are meet. This is still considered a PASS, but will be a Notification:

  • 3Days_Production_hrs:
    • WTG did NOT show total power production for 72 hours or more.
  • LastDayProduction_hrs:
    • WTG did NOT produce power where WindSpeed > 3ms and RealPower > 250 kw on the last day of data sample
DateStart = 2024-12-23 00:00 / DateEnd = 2024-12-25 00:00 
WTG Rating (k/w) MaxPower (k/w) 98% of Rated TotalProduction (k/w) ReachRated_hrs 3Days_Production_hrs LastDayProduction_hrs
WTG-0001 2500 743.12 29.72% 6477.98 0 12.33 6
WTG-0002 2500 1828.88 73.16% 16106.46 0 21.83 10
WTG-0003 2500 2830.73 113.23% 49806.53 5.83 31.33 19.83
WTG-0004 2500 2831.38 113.26% 43364.08 4.17 30.83 19
WTG-0005 2500 2830.42 113.22% 56658.76 7.67 31.5 20
WTG-0006 2500 2219.25 88.77% 14062.91 0 9.17 3
WTG-0007 2500 -2.81 0% -212.14 0 0 0
WTG-0008 2500 1917.92 76.72% 770.67 0 0.83 0
WTG-0009 2500 2831.05 113.24% 53958.80 7 31.5 19.67
WTG-0010 2500 2830.69 113.23% 54824.20 7.67 31.5 19.67
WTG-0011 2500 1386.31 55.45% 1397.51 0 2 0
WTG-0012 2500 2830.35 113.21% 33123.07 2.33 29.67 19.67
WTG-0013 2500 2830.47 113.22% 45525.31 4.17 29.67 19.5
WTG-0014 2500 2529.95 101.2% 23735.19 0.83 27.67 16.33
WTG-0015 2500 2830.96 113.24% 46643.99 6 30.83 19.5
WTG-0016 2500 -3.06 0% -203.03 0 0 0
WTG-0017 2500 2830.52 113.22% 37739.30 4 31.17 19.33
WTG-0018 2500 2029.78 81.19% 1648.87 0 1.67 0
WTG-0019 2500 1327.57 53.1% 14584.82 0 22.83 11.17
WTG-0020 2500 2830.77 113.23% 51958.46 4.17 33.17 21.33
WTG-0021 2500 2830.71 113.23% 61238.87 6.17 32.83 21.5
WTG-0022 2500 2830.61 113.22% 56090.69 5.17 33.17 21.33
WTG-0023 2500 2830.45 113.22% 56324.20 8 30.33 20
WTG-0024 2500 2830.51 113.22% 49403.87 5 32 20.17
WTG-0025 2500 2725.56 109.02% 51159.09 4 31.67 20.83
WTG-0026 2500 2086.68 83.47% 7904.29 0 8.5 0
WTG-0027 2500 2830.95 113.24% 58200.97 8.33 31.83 20.5
WTG-0028 2500 2831.47 113.26% 52482.13 5.17 32.33 20.67
WTG-0029 2500 67.27 2.69% -239.92 0 0 0
WTG-0030 2500 2235.46 89.42% 47845.79 0 31.17 20.5
WTG-0031 2500 2830.68 113.23% 58181.36 6.17 32 20.33
WTG-0032 2500 2830.32 113.21% 52058.69 5.67 32 20.67
WTG-0033 2500 2830.96 113.24% 50302.13 5 31.83 20.67
WTG-0034 2500 2830.82 113.23% 53035.10 5 31.33 20.17
WTG-0035 2500 533.07 21.32% 452.46 0 1.17 0
WTG-0036 2500 190.8 7.63% -183.07 0 0 0
WTG-0037 2500 2830.81 113.23% 50545.72 5.83 32.83 21.67
WTG-0038 2500 -3.05 0% -237.84 0 0 0
WTG-0039 2500 1806.39 72.26% 37425.98 0 32.17 21
WTG-0040 2500 2830.2 113.21% 46461.35 3.67 32.17 21
WTG-0041 2500 1910.86 76.43% 1257.48 0 1.17 0
WTG-0042 2500 2237.23 89.49% 44187.20 0 32.5 20.83
WTG-0043 2500 2237.54 89.5% 45317.11 0 33.17 21.5
WTG-0044 2500 2831.52 113.26% 56745.03 5.67 32 20.83
WTG-0045 2500 2830.87 113.23% 59077.73 7.5 31.67 21.67
WTG-0046 2500 2725.37 109.01% 51435.23 6 32.83 21.17
WTG-0047 2500 2237.89 89.52% 35375.04 0 31.17 20.33
WTG-0048 2500 2003.03 80.12% 21369.28 0 21.83 10.33
WTG-0049 2500 2830.67 113.23% 41555.54 3.67 31.67 20
WTG-0050 2500 1699.85 67.99% 33448.44 0 29.33 19.33
WTG-0051 2500 2830.93 113.24% 50630.74 5.17 31.5 20.17
WTG-0052 2500 2725.46 109.02% 52526.99 3.17 33 21.33
WTG-0053 2500 2725.69 109.03% 52635.04 4.33 32.67 21.33
WTG-0054 2500 2830.41 113.22% 55411.55 5.5 31.67 20.5
WTG-0055 2500 2504.88 100.2% 34965.90 0.17 20.17 13.17
WTG-0056 2500 716.2 28.65% 391.20 0 1 0
WTG-0057 2500 200.6 8.02% 6452.88 0 0 0
WTG-0058 2500 1903.5 76.14% 43592.31 0 31.67 21.5
WTG-0059 2500 2830.99 113.24% 47982.13 3.83 31.33 20.5
WTG-0060 2500 2530.5 101.22% 31459.50 3.5 28.17 20.33
WTG-0061 2500 2831.26 113.25% 62047.80 12 29.33 21.83
WTG-0062 2500 2831.54 113.26% 57741.94 6.17 33 21.67
WTG-0063 2500 2830.4 113.22% 35359.89 5.67 23.67 16
WTG-0064 2500 2830.42 113.22% 59508.01 7.33 31 20.67
WTG-0065 2500 2830.5 113.22% 32992.73 3.33 31 20.5
WTG-0066 2500 2830.76 113.23% 49003.79 6 28.83 21.5
WTG-0067 2500 886.89 35.48% 3812.40 0 8.67 0
WTG-0068 2500 2830.86 113.23% 62817.12 7.5 33.5 22.17
WTG-0069 2500 2205.88 88.24% 13901.77 0 10.67 4.83
WTG-0070 2500 2182.93 87.32% 7340.42 0 7.5 1.17
WTG-0071 2500 2531.53 101.26% 25515.14 1.5 26.5 19
WTG-0072 2500 2830.08 113.2% 33513.09 2.83 28.33 21
WTG-0073 2500 2830.93 113.24% 46860.02 5.83 30.17 19.5

WTGs With Not Enough Data to Process

Find all WTGS that will not have enough or correct data to process Power Values.

  • RealPower data will NOT plot with Zero or Negative Power Values
  • Filter out WTGS that had less then 5 rows of data where RealPower > 0
  • WTG did NOT reach rated power
[1] "WTG - WTG-0001 - WTG did NOT reach rated power."
[1] "WTG - WTG-0019 - WTG did NOT reach rated power."
[1] "WTG - WTG-0002 - WTG did NOT reach rated power."
[1] "WTG - WTG-0006 - WTG did NOT reach rated power."
[1] "WTG - WTG-0007 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0008 - WTG did NOT reach rated power."
[1] "WTG - WTG-0011 - WTG did NOT reach rated power."
[1] "WTG - WTG-0016 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0018 - WTG did NOT reach rated power."
[1] "WTG - WTG-0026 - WTG did NOT reach rated power."
[1] "WTG - WTG-0029 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0030 - WTG did NOT reach rated power."
[1] "WTG - WTG-0035 - WTG did NOT reach rated power."
[1] "WTG - WTG-0036 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0038 - WTG does NOT have enough data to evaluate properly and accurately."
[1] "WTG - WTG-0039 - WTG did NOT reach rated power."
[1] "WTG - WTG-0041 - WTG did NOT reach rated power."
[1] "WTG - WTG-0042 - WTG did NOT reach rated power."
[1] "WTG - WTG-0043 - WTG did NOT reach rated power."
[1] "WTG - WTG-0047 - WTG did NOT reach rated power."
[1] "WTG - WTG-0048 - WTG did NOT reach rated power."
[1] "WTG - WTG-0050 - WTG did NOT reach rated power."
[1] "WTG - WTG-0056 - WTG did NOT reach rated power."
[1] "WTG - WTG-0057 - WTG did NOT reach rated power."
[1] "WTG - WTG-0058 - WTG did NOT reach rated power."
[1] "WTG - WTG-0067 - WTG did NOT reach rated power."
[1] "WTG - WTG-0069 - WTG did NOT reach rated power."
[1] "WTG - WTG-0070 - WTG did NOT reach rated power."

Power Plots for test WTGs:

1. Did NOT Reach Rated Power; 2. Reach Rated Power

1. DID NOT Reached Rated Power

2. Reached Rated Power Plots